CREATE
OR REPLACE PROCEDURE project_tb_insert_project_sp(p_phid IN NUMBER) AS BEGIN
INSERT INTO
    crm3_tend_eval(
        phid,
        phid_org,
        user_djly,
        user_xmmc1,
        user_bdmc,
        user_xmyzmc,
        g_situation,
        user_tbr,
        user_xmszd,
        bill_dt,
         bill_no, bill_name, phid_tenmode, phid_conmode, phid_pc, tend_address, prc_range, cnt_type, pay_type, 
    eval_type, manager_req, cnt_range, con_range, asr_flag, wf_flag, 
    arc_flag, phid_app, app_status, level_code, print_count, 
    bill_type, py, phid_schemeid, 
    ng_record_ver, creator, editor, cur_orgid, phid_sourcemid, item_resource, 
    ng_phid_cu, ng_phid_bp, ng_phid_org, ng_phid_ui_scheme, ng_phid_original, 
    ng_orgid_original, ng_sv_search_key, ng_sd_search_key, ng_share_sign, 
    isimport, list_filter_val, query_field1_val, query_field2_val, 
    uimulti_config_id, ng_write_source
    )
SELECT
    seq_auto_phid_project_tb_to_project_sp.nextval,
    phid_org,
    p_phid,
    project_name,
    user_bdmc,
    user_yzdw,
    g_situation,
    phid_tbpsn,
    user_xmszd,
    bill_dt,
    bill_no,
    '', 
    0, 
    0, 
    0,
    '', 
    '', 
    '', 
    '',
    '', 
    '', 
    '', 
    '', 
    0, 
    0,
    NULL, 
    0, 
    0, 
    0, 
    0,
    '', 
    '', 
    6870000000000034,  
    5, 
    0, 
    0, 
    1, 
    NULL, 
    NULL,
    1, 
    0, 
    1, 
    0, 
    0, 
    0,
    10, 
    1, 
    5, 
    1, 
    NULL, 
    NULL,
    NULL, 
    NULL,
    ''
from
    crm3_advance_project
where 
    phid = p_phid; 
    commit;
    EXCEPTION 
    WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('插入失败，错误信息：' || SQLERRM);
    RAISE;
    ROLLBACK;
END project_tb_insert_project_sp;